Dataset statistics
| Number of variables | 26 |
|---|---|
| Number of observations | 18004 |
| Missing cells | 86954 |
| Missing cells (%) | 18.6% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 3.6 MiB |
| Average record size in memory | 208.0 B |
Variable types
| Categorical | 12 |
|---|---|
| Numeric | 14 |
has_deposit is highly correlated with is_converted | High correlation |
mifid_money_other_brokers is highly correlated with mifid_invested_other_brokers | High correlation |
mifid_invested_other_brokers is highly correlated with mifid_money_other_brokers | High correlation |
is_converted is highly correlated with has_deposit | High correlation |
is_converted is highly correlated with has_deposit | High correlation |
has_deposit is highly correlated with is_converted | High correlation |
finish_mifid_days has 7549 (41.9%) missing values | Missing |
first_deposit_days has 12948 (71.9%) missing values | Missing |
linked_account_days has 17376 (96.5%) missing values | Missing |
demo_account_days has 15289 (84.9%) missing values | Missing |
demo_trade_days has 15856 (88.1%) missing values | Missing |
mock_account_days has 17927 (99.6%) missing values | Missing |
first_deposit_amount is highly skewed (γ1 = 27.52959369) | Skewed |
start_mifid_days has 12212 (67.8%) zeros | Zeros |
finish_mifid_days has 2226 (12.4%) zeros | Zeros |
first_deposit_days has 204 (1.1%) zeros | Zeros |
first_deposit_amount has 12948 (71.9%) zeros | Zeros |
first_deposit_platform has 1923 (10.7%) zeros | Zeros |
mifid_actual_savings has 1548 (8.6%) zeros | Zeros |
mifid_next_year_savings has 1548 (8.6%) zeros | Zeros |
mifid_invested_other_brokers has 8277 (46.0%) zeros | Zeros |
linked_account_days has 303 (1.7%) zeros | Zeros |
demo_account_days has 2065 (11.5%) zeros | Zeros |
demo_trade_days has 610 (3.4%) zeros | Zeros |
Reproduction
| Analysis started | 2021-06-02 18:20:29.982607 |
|---|---|
| Analysis finished | 2021-06-02 18:21:46.515469 |
| Duration | 1 minute and 16.53 seconds |
| Software version | pandas-profiling v2.13.0 |
| Download configuration | config.yaml |
user_currency
Categorical
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 140.8 KiB |
| USD | |
|---|---|
| EUR | |
| GBP | 844 |
| NO_CURRENCY | 3 |
Length
| Max length | 11 |
|---|---|
| Median length | 3 |
| Mean length | 3.001333037 |
| Min length | 3 |
Characters and Unicode
| Total characters | 54036 |
|---|---|
| Distinct characters | 13 |
| Distinct categories | 2 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | EUR |
|---|---|
| 2nd row | EUR |
| 3rd row | USD |
| 4th row | USD |
| 5th row | USD |
| Value | Count | Frequency (%) |
| USD | 10731 | |
| EUR | 6426 | |
| GBP | 844 | 4.7% |
| NO_CURRENCY | 3 | < 0.1% |
| Value | Count | Frequency (%) |
| usd | 10731 | |
| eur | 6426 | |
| gbp | 844 | 4.7% |
| no_currency | 3 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| U | 17160 | |
| S | 10731 | |
| D | 10731 | |
| R | 6432 | 11.9% |
| E | 6429 | 11.9% |
| G | 844 | 1.6% |
| B | 844 | 1.6% |
| P | 844 | 1.6% |
| N | 6 | < 0.1% |
| C | 6 | < 0.1% |
| Other values (3) | 9 | < 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 54033 | |
| Connector Punctuation | 3 | < 0.1% |
Most frequent character per category
| Value | Count | Frequency (%) |
| U | 17160 | |
| S | 10731 | |
| D | 10731 | |
| R | 6432 | 11.9% |
| E | 6429 | 11.9% |
| G | 844 | 1.6% |
| B | 844 | 1.6% |
| P | 844 | 1.6% |
| N | 6 | < 0.1% |
| C | 6 | < 0.1% |
| Other values (2) | 6 | < 0.1% |
| Value | Count | Frequency (%) |
| _ | 3 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 54033 | |
| Common | 3 | < 0.1% |
Most frequent character per script
| Value | Count | Frequency (%) |
| U | 17160 | |
| S | 10731 | |
| D | 10731 | |
| R | 6432 | 11.9% |
| E | 6429 | 11.9% |
| G | 844 | 1.6% |
| B | 844 | 1.6% |
| P | 844 | 1.6% |
| N | 6 | < 0.1% |
| C | 6 | < 0.1% |
| Other values (2) | 6 | < 0.1% |
| Value | Count | Frequency (%) |
| _ | 3 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 54036 |
Most frequent character per block
| Value | Count | Frequency (%) |
| U | 17160 | |
| S | 10731 | |
| D | 10731 | |
| R | 6432 | 11.9% |
| E | 6429 | 11.9% |
| G | 844 | 1.6% |
| B | 844 | 1.6% |
| P | 844 | 1.6% |
| N | 6 | < 0.1% |
| C | 6 | < 0.1% |
| Other values (3) | 9 | < 0.1% |
user_country
Real number (ℝ≥0)
| Distinct | 162 |
|---|---|
| Distinct (%) | 0.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 66.27255054 |
| Minimum | 0 |
|---|---|
| Maximum | 161 |
| Zeros | 32 |
| Zeros (%) | 0.2% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 140.8 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 8 |
| Q1 | 32 |
| median | 46 |
| Q3 | 100 |
| 95-th percentile | 160 |
| Maximum | 161 |
| Range | 161 |
| Interquartile range (IQR) | 68 |
Descriptive statistics
| Standard deviation | 44.54543168 |
|---|---|
| Coefficient of variation (CV) | 0.6721550826 |
| Kurtosis | -0.4137371428 |
| Mean | 66.27255054 |
| Median Absolute Deviation (MAD) | 16 |
| Skewness | 0.874743413 |
| Sum | 1193171 |
| Variance | 1984.295484 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 46 | 4438 | |
| 31 | 1240 | 6.9% |
| 53 | 1102 | 6.1% |
| 160 | 1101 | 6.1% |
| 100 | 968 | 5.4% |
| 8 | 783 | 4.3% |
| 30 | 569 | 3.2% |
| 111 | 535 | 3.0% |
| 28 | 452 | 2.5% |
| 43 | 411 | 2.3% |
| Other values (152) | 6405 |
| Value | Count | Frequency (%) |
| 0 | 32 | 0.2% |
| 1 | 102 | |
| 2 | 1 | < 0.1% |
| 3 | 1 | < 0.1% |
| 4 | 7 | < 0.1% |
| Value | Count | Frequency (%) |
| 161 | 298 | 1.7% |
| 160 | 1101 | |
| 159 | 3 | < 0.1% |
| 158 | 1 | < 0.1% |
| 157 | 6 | < 0.1% |
| Distinct | 584 |
|---|---|
| Distinct (%) | 3.2% |
| Missing | 9 |
| Missing (%) | < 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 25.63728814 |
| Minimum | 0 |
|---|---|
| Maximum | 1112 |
| Zeros | 12212 |
| Zeros (%) | 67.8% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 140.8 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 3 |
| 95-th percentile | 163 |
| Maximum | 1112 |
| Range | 1112 |
| Interquartile range (IQR) | 3 |
Descriptive statistics
| Standard deviation | 87.79499459 |
|---|---|
| Coefficient of variation (CV) | 3.424503954 |
| Kurtosis | 34.78382969 |
| Mean | 25.63728814 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 5.347203868 |
| Sum | 461343 |
| Variance | 7707.961075 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 12212 | |
| 1 | 853 | 4.7% |
| 2 | 367 | 2.0% |
| 3 | 250 | 1.4% |
| 4 | 231 | 1.3% |
| 5 | 141 | 0.8% |
| 7 | 135 | 0.7% |
| 6 | 120 | 0.7% |
| 8 | 107 | 0.6% |
| 11 | 83 | 0.5% |
| Other values (574) | 3496 | 19.4% |
| Value | Count | Frequency (%) |
| 0 | 12212 | |
| 1 | 853 | 4.7% |
| 2 | 367 | 2.0% |
| 3 | 250 | 1.4% |
| 4 | 231 | 1.3% |
| Value | Count | Frequency (%) |
| 1112 | 1 | |
| 1079 | 1 | |
| 1033 | 1 | |
| 1019 | 1 | |
| 980 | 1 |
has_finished_mifid
Categorical
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 140.8 KiB |
| 1 | |
|---|---|
| 0 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 18004 |
|---|---|
| Distinct characters | 2 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 1 |
|---|---|
| 2nd row | 1 |
| 3rd row | 1 |
| 4th row | 0 |
| 5th row | 0 |
| Value | Count | Frequency (%) |
| 1 | 10454 | |
| 0 | 7550 |
| Value | Count | Frequency (%) |
| 1 | 10454 | |
| 0 | 7550 |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 10454 | |
| 0 | 7550 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 18004 |
Most frequent character per category
| Value | Count | Frequency (%) |
| 1 | 10454 | |
| 0 | 7550 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 18004 |
Most frequent character per script
| Value | Count | Frequency (%) |
| 1 | 10454 | |
| 0 | 7550 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 18004 |
Most frequent character per block
| Value | Count | Frequency (%) |
| 1 | 10454 | |
| 0 | 7550 |
| Distinct | 580 |
|---|---|
| Distinct (%) | 5.5% |
| Missing | 7549 |
| Missing (%) | 41.9% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 43.18278336 |
| Minimum | 0 |
|---|---|
| Maximum | 1114 |
| Zeros | 2226 |
| Zeros (%) | 12.4% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 140.8 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 1 |
| median | 3 |
| Q3 | 21 |
| 95-th percentile | 265 |
| Maximum | 1114 |
| Range | 1114 |
| Interquartile range (IQR) | 20 |
Descriptive statistics
| Standard deviation | 111.319832 |
|---|---|
| Coefficient of variation (CV) | 2.577875333 |
| Kurtosis | 20.12343614 |
| Mean | 43.18278336 |
| Median Absolute Deviation (MAD) | 3 |
| Skewness | 4.11168237 |
| Sum | 451476 |
| Variance | 12392.105 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 2226 | 12.4% |
| 1 | 2028 | 11.3% |
| 2 | 899 | 5.0% |
| 3 | 570 | 3.2% |
| 4 | 368 | 2.0% |
| 5 | 274 | 1.5% |
| 6 | 206 | 1.1% |
| 7 | 183 | 1.0% |
| 8 | 146 | 0.8% |
| 9 | 101 | 0.6% |
| Other values (570) | 3454 | |
| (Missing) | 7549 |
| Value | Count | Frequency (%) |
| 0 | 2226 | |
| 1 | 2028 | |
| 2 | 899 | |
| 3 | 570 | 3.2% |
| 4 | 368 | 2.0% |
| Value | Count | Frequency (%) |
| 1114 | 1 | |
| 1085 | 1 | |
| 1033 | 1 | |
| 1019 | 1 | |
| 980 | 1 |
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 140.8 KiB |
| 0 | |
|---|---|
| 1 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 18004 |
|---|---|
| Distinct characters | 2 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 1 |
|---|---|
| 2nd row | 1 |
| 3rd row | 0 |
| 4th row | 0 |
| 5th row | 0 |
| Value | Count | Frequency (%) |
| 0 | 12948 | |
| 1 | 5056 | 28.1% |
| Value | Count | Frequency (%) |
| 0 | 12948 | |
| 1 | 5056 | 28.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 12948 | |
| 1 | 5056 | 28.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 18004 |
Most frequent character per category
| Value | Count | Frequency (%) |
| 0 | 12948 | |
| 1 | 5056 | 28.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 18004 |
Most frequent character per script
| Value | Count | Frequency (%) |
| 0 | 12948 | |
| 1 | 5056 | 28.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 18004 |
Most frequent character per block
| Value | Count | Frequency (%) |
| 0 | 12948 | |
| 1 | 5056 | 28.1% |
| Distinct | 540 |
|---|---|
| Distinct (%) | 10.7% |
| Missing | 12948 |
| Missing (%) | 71.9% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 80.04786392 |
| Minimum | 0 |
|---|---|
| Maximum | 1105 |
| Zeros | 204 |
| Zeros (%) | 1.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 140.8 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 5 |
| median | 18 |
| Q3 | 82 |
| 95-th percentile | 392.25 |
| Maximum | 1105 |
| Range | 1105 |
| Interquartile range (IQR) | 77 |
Descriptive statistics
| Standard deviation | 142.6826422 |
|---|---|
| Coefficient of variation (CV) | 1.782466579 |
| Kurtosis | 9.780455233 |
| Mean | 80.04786392 |
| Median Absolute Deviation (MAD) | 16 |
| Skewness | 2.911367192 |
| Sum | 404722 |
| Variance | 20358.33638 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1 | 289 | 1.6% |
| 3 | 247 | 1.4% |
| 2 | 242 | 1.3% |
| 0 | 204 | 1.1% |
| 4 | 197 | 1.1% |
| 6 | 184 | 1.0% |
| 5 | 177 | 1.0% |
| 7 | 148 | 0.8% |
| 8 | 119 | 0.7% |
| 9 | 116 | 0.6% |
| Other values (530) | 3133 | 17.4% |
| (Missing) | 12948 |
| Value | Count | Frequency (%) |
| 0 | 204 | |
| 1 | 289 | |
| 2 | 242 | |
| 3 | 247 | |
| 4 | 197 |
| Value | Count | Frequency (%) |
| 1105 | 1 | |
| 1085 | 1 | |
| 1044 | 1 | |
| 1019 | 1 | |
| 983 | 1 |
| Distinct | 671 |
|---|---|
| Distinct (%) | 3.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.904987805 |
| Minimum | 0 |
|---|---|
| Maximum | 1000 |
| Zeros | 12948 |
| Zeros (%) | 71.9% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 140.8 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 2 |
| 95-th percentile | 12 |
| Maximum | 1000 |
| Range | 1000 |
| Interquartile range (IQR) | 2 |
Descriptive statistics
| Standard deviation | 17.75249612 |
|---|---|
| Coefficient of variation (CV) | 6.111039808 |
| Kurtosis | 1167.017172 |
| Mean | 2.904987805 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 27.52959369 |
| Sum | 52301.40044 |
| Variance | 315.1511184 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 12948 | |
| 2 | 1754 | 9.7% |
| 4 | 880 | 4.9% |
| 8 | 258 | 1.4% |
| 20 | 199 | 1.1% |
| 2.4 | 131 | 0.7% |
| 40 | 124 | 0.7% |
| 12 | 122 | 0.7% |
| 6 | 102 | 0.6% |
| 10 | 68 | 0.4% |
| Other values (661) | 1418 | 7.9% |
| Value | Count | Frequency (%) |
| 0 | 12948 | |
| 0.01116 | 1 | < 0.1% |
| 0.02192 | 1 | < 0.1% |
| 0.028 | 1 | < 0.1% |
| 0.03036 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 1000 | 1 | |
| 879.754 | 1 | |
| 739.38 | 1 | |
| 400 | 2 | |
| 399.974 | 1 |
| Distinct | 7 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.467396134 |
| Minimum | 0 |
|---|---|
| Maximum | 6 |
| Zeros | 1923 |
| Zeros (%) | 10.7% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 140.8 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 1 |
| median | 1 |
| Q3 | 1 |
| 95-th percentile | 5 |
| Maximum | 6 |
| Range | 6 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 1.394194913 |
|---|---|
| Coefficient of variation (CV) | 0.9501148875 |
| Kurtosis | 2.01614035 |
| Mean | 1.467396134 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 1.785887667 |
| Sum | 26419 |
| Variance | 1.943779455 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1 | 12948 | |
| 0 | 1923 | 10.7% |
| 5 | 1685 | 9.4% |
| 3 | 916 | 5.1% |
| 4 | 389 | 2.2% |
| 6 | 114 | 0.6% |
| 2 | 29 | 0.2% |
| Value | Count | Frequency (%) |
| 0 | 1923 | 10.7% |
| 1 | 12948 | |
| 2 | 29 | 0.2% |
| 3 | 916 | 5.1% |
| 4 | 389 | 2.2% |
| Value | Count | Frequency (%) |
| 6 | 114 | 0.6% |
| 5 | 1685 | |
| 4 | 389 | 2.2% |
| 3 | 916 | |
| 2 | 29 | 0.2% |
| Distinct | 11 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 8.924850033 |
| Minimum | 0 |
|---|---|
| Maximum | 15 |
| Zeros | 1548 |
| Zeros (%) | 8.6% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 140.8 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 6 |
| median | 10 |
| Q3 | 12 |
| 95-th percentile | 13 |
| Maximum | 15 |
| Range | 15 |
| Interquartile range (IQR) | 6 |
Descriptive statistics
| Standard deviation | 3.993755347 |
|---|---|
| Coefficient of variation (CV) | 0.4474871098 |
| Kurtosis | -0.3709338517 |
| Mean | 8.924850033 |
| Median Absolute Deviation (MAD) | 3 |
| Skewness | -0.7651481344 |
| Sum | 160683 |
| Variance | 15.95008177 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 12 | 5852 | |
| 13 | 2788 | |
| 5 | 2116 | 11.8% |
| 6 | 1684 | 9.4% |
| 7 | 1609 | 8.9% |
| 0 | 1548 | 8.6% |
| 8 | 1125 | 6.2% |
| 9 | 674 | 3.7% |
| 10 | 294 | 1.6% |
| 15 | 202 | 1.1% |
| Value | Count | Frequency (%) |
| 0 | 1548 | |
| 5 | 2116 | |
| 6 | 1684 | |
| 7 | 1609 | |
| 8 | 1125 |
| Value | Count | Frequency (%) |
| 15 | 202 | 1.1% |
| 13 | 2788 | |
| 12 | 5852 | |
| 11 | 112 | 0.6% |
| 10 | 294 | 1.6% |
| Distinct | 11 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 8.462563875 |
| Minimum | 0 |
|---|---|
| Maximum | 15 |
| Zeros | 1548 |
| Zeros (%) | 8.6% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 140.8 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 6 |
| median | 8 |
| Q3 | 12 |
| 95-th percentile | 13 |
| Maximum | 15 |
| Range | 15 |
| Interquartile range (IQR) | 6 |
Descriptive statistics
| Standard deviation | 3.989778698 |
|---|---|
| Coefficient of variation (CV) | 0.4714621664 |
| Kurtosis | -0.640226688 |
| Mean | 8.462563875 |
| Median Absolute Deviation (MAD) | 3 |
| Skewness | -0.4852894058 |
| Sum | 152360 |
| Variance | 15.91833406 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 12 | 3964 | |
| 13 | 3204 | |
| 5 | 2718 | |
| 6 | 2105 | |
| 7 | 1929 | |
| 0 | 1548 | 8.6% |
| 8 | 1231 | 6.8% |
| 9 | 634 | 3.5% |
| 10 | 306 | 1.7% |
| 15 | 197 | 1.1% |
| Value | Count | Frequency (%) |
| 0 | 1548 | |
| 5 | 2718 | |
| 6 | 2105 | |
| 7 | 1929 | |
| 8 | 1231 |
| Value | Count | Frequency (%) |
| 15 | 197 | 1.1% |
| 13 | 3204 | |
| 12 | 3964 | |
| 11 | 168 | 0.9% |
| 10 | 306 | 1.7% |
mifid_qualifications
Categorical
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 140.8 KiB |
| 1 | |
|---|---|
| 0 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 18004 |
|---|---|
| Distinct characters | 2 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 1 |
|---|---|
| 2nd row | 1 |
| 3rd row | 1 |
| 4th row | 0 |
| 5th row | 0 |
| Value | Count | Frequency (%) |
| 1 | 10876 | |
| 0 | 7128 |
| Value | Count | Frequency (%) |
| 1 | 10876 | |
| 0 | 7128 |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 10876 | |
| 0 | 7128 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 18004 |
Most frequent character per category
| Value | Count | Frequency (%) |
| 1 | 10876 | |
| 0 | 7128 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 18004 |
Most frequent character per script
| Value | Count | Frequency (%) |
| 1 | 10876 | |
| 0 | 7128 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 18004 |
Most frequent character per block
| Value | Count | Frequency (%) |
| 1 | 10876 | |
| 0 | 7128 |
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 140.8 KiB |
| 1 | |
|---|---|
| 0 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 18004 |
|---|---|
| Distinct characters | 2 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 1 |
|---|---|
| 2nd row | 1 |
| 3rd row | 1 |
| 4th row | 1 |
| 5th row | 0 |
| Value | Count | Frequency (%) |
| 1 | 9728 | |
| 0 | 8276 |
| Value | Count | Frequency (%) |
| 1 | 9728 | |
| 0 | 8276 |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 9728 | |
| 0 | 8276 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 18004 |
Most frequent character per category
| Value | Count | Frequency (%) |
| 1 | 9728 | |
| 0 | 8276 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 18004 |
Most frequent character per script
| Value | Count | Frequency (%) |
| 1 | 9728 | |
| 0 | 8276 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 18004 |
Most frequent character per block
| Value | Count | Frequency (%) |
| 1 | 9728 | |
| 0 | 8276 |
| Distinct | 11 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 5.519828927 |
| Minimum | 0 |
|---|---|
| Maximum | 15 |
| Zeros | 8277 |
| Zeros (%) | 46.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 140.8 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 5 |
| Q3 | 12 |
| 95-th percentile | 13 |
| Maximum | 15 |
| Range | 15 |
| Interquartile range (IQR) | 12 |
Descriptive statistics
| Standard deviation | 5.532329734 |
|---|---|
| Coefficient of variation (CV) | 1.002264709 |
| Kurtosis | -1.732979537 |
| Mean | 5.519828927 |
| Median Absolute Deviation (MAD) | 5 |
| Skewness | 0.2007539217 |
| Sum | 99379 |
| Variance | 30.60667228 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 8277 | |
| 12 | 4659 | |
| 13 | 1581 | 8.8% |
| 5 | 1195 | 6.6% |
| 6 | 808 | 4.5% |
| 7 | 640 | 3.6% |
| 8 | 441 | 2.4% |
| 9 | 229 | 1.3% |
| 10 | 84 | 0.5% |
| 15 | 49 | 0.3% |
| Value | Count | Frequency (%) |
| 0 | 8277 | |
| 5 | 1195 | 6.6% |
| 6 | 808 | 4.5% |
| 7 | 640 | 3.6% |
| 8 | 441 | 2.4% |
| Value | Count | Frequency (%) |
| 15 | 49 | 0.3% |
| 13 | 1581 | 8.8% |
| 12 | 4659 | |
| 11 | 41 | 0.2% |
| 10 | 84 | 0.5% |
mifid_experience
Categorical
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 140.8 KiB |
| 0 | |
|---|---|
| 1 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 18004 |
|---|---|
| Distinct characters | 2 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 1 |
|---|---|
| 2nd row | 0 |
| 3rd row | 0 |
| 4th row | 0 |
| 5th row | 0 |
| Value | Count | Frequency (%) |
| 0 | 9936 | |
| 1 | 8068 |
| Value | Count | Frequency (%) |
| 0 | 9936 | |
| 1 | 8068 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 9936 | |
| 1 | 8068 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 18004 |
Most frequent character per category
| Value | Count | Frequency (%) |
| 0 | 9936 | |
| 1 | 8068 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 18004 |
Most frequent character per script
| Value | Count | Frequency (%) |
| 0 | 9936 | |
| 1 | 8068 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 18004 |
Most frequent character per block
| Value | Count | Frequency (%) |
| 0 | 9936 | |
| 1 | 8068 |
has_linked_account
Categorical
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 140.8 KiB |
| 0 | |
|---|---|
| 1 | 628 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 18004 |
|---|---|
| Distinct characters | 2 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0 |
|---|---|
| 2nd row | 0 |
| 3rd row | 0 |
| 4th row | 0 |
| 5th row | 0 |
| Value | Count | Frequency (%) |
| 0 | 17376 | |
| 1 | 628 | 3.5% |
| Value | Count | Frequency (%) |
| 0 | 17376 | |
| 1 | 628 | 3.5% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 17376 | |
| 1 | 628 | 3.5% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 18004 |
Most frequent character per category
| Value | Count | Frequency (%) |
| 0 | 17376 | |
| 1 | 628 | 3.5% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 18004 |
Most frequent character per script
| Value | Count | Frequency (%) |
| 0 | 17376 | |
| 1 | 628 | 3.5% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 18004 |
Most frequent character per block
| Value | Count | Frequency (%) |
| 0 | 17376 | |
| 1 | 628 | 3.5% |
| Distinct | 126 |
|---|---|
| Distinct (%) | 20.1% |
| Missing | 17376 |
| Missing (%) | 96.5% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 35.64171975 |
| Minimum | 0 |
|---|---|
| Maximum | 1033 |
| Zeros | 303 |
| Zeros (%) | 1.7% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 140.8 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 1 |
| Q3 | 14 |
| 95-th percentile | 231 |
| Maximum | 1033 |
| Range | 1033 |
| Interquartile range (IQR) | 14 |
Descriptive statistics
| Standard deviation | 102.2977983 |
|---|---|
| Coefficient of variation (CV) | 2.870170099 |
| Kurtosis | 30.56520024 |
| Mean | 35.64171975 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | 4.888651126 |
| Sum | 22383 |
| Variance | 10464.83953 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 303 | 1.7% |
| 1 | 53 | 0.3% |
| 2 | 30 | 0.2% |
| 3 | 28 | 0.2% |
| 4 | 14 | 0.1% |
| 6 | 8 | < 0.1% |
| 10 | 8 | < 0.1% |
| 5 | 6 | < 0.1% |
| 17 | 5 | < 0.1% |
| 8 | 5 | < 0.1% |
| Other values (116) | 168 | 0.9% |
| (Missing) | 17376 |
| Value | Count | Frequency (%) |
| 0 | 303 | |
| 1 | 53 | 0.3% |
| 2 | 30 | 0.2% |
| 3 | 28 | 0.2% |
| 4 | 14 | 0.1% |
| Value | Count | Frequency (%) |
| 1033 | 1 | |
| 838 | 1 | |
| 728 | 1 | |
| 642 | 1 | |
| 620 | 1 |
has_demo_account
Categorical
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 140.8 KiB |
| 0 | |
|---|---|
| 1 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 18004 |
|---|---|
| Distinct characters | 2 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0 |
|---|---|
| 2nd row | 0 |
| 3rd row | 0 |
| 4th row | 0 |
| 5th row | 0 |
| Value | Count | Frequency (%) |
| 0 | 15289 | |
| 1 | 2715 | 15.1% |
| Value | Count | Frequency (%) |
| 0 | 15289 | |
| 1 | 2715 | 15.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 15289 | |
| 1 | 2715 | 15.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 18004 |
Most frequent character per category
| Value | Count | Frequency (%) |
| 0 | 15289 | |
| 1 | 2715 | 15.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 18004 |
Most frequent character per script
| Value | Count | Frequency (%) |
| 0 | 15289 | |
| 1 | 2715 | 15.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 18004 |
Most frequent character per block
| Value | Count | Frequency (%) |
| 0 | 15289 | |
| 1 | 2715 | 15.1% |
| Distinct | 166 |
|---|---|
| Distinct (%) | 6.1% |
| Missing | 15289 |
| Missing (%) | 84.9% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 13.5145488 |
| Minimum | 0 |
|---|---|
| Maximum | 1019 |
| Zeros | 2065 |
| Zeros (%) | 11.5% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 140.8 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 50.3 |
| Maximum | 1019 |
| Range | 1019 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 64.89988939 |
|---|---|
| Coefficient of variation (CV) | 4.80222391 |
| Kurtosis | 68.79046175 |
| Mean | 13.5145488 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 7.484010319 |
| Sum | 36692 |
| Variance | 4211.995643 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 2065 | 11.5% |
| 1 | 109 | 0.6% |
| 2 | 53 | 0.3% |
| 4 | 43 | 0.2% |
| 3 | 40 | 0.2% |
| 5 | 31 | 0.2% |
| 7 | 23 | 0.1% |
| 6 | 22 | 0.1% |
| 9 | 19 | 0.1% |
| 11 | 14 | 0.1% |
| Other values (156) | 296 | 1.6% |
| (Missing) | 15289 |
| Value | Count | Frequency (%) |
| 0 | 2065 | |
| 1 | 109 | 0.6% |
| 2 | 53 | 0.3% |
| 3 | 40 | 0.2% |
| 4 | 43 | 0.2% |
| Value | Count | Frequency (%) |
| 1019 | 1 | |
| 792 | 1 | |
| 758 | 1 | |
| 729 | 1 | |
| 671 | 1 |
has_demo_trade
Categorical
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 140.8 KiB |
| 0 | |
|---|---|
| 1 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 18004 |
|---|---|
| Distinct characters | 2 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0 |
|---|---|
| 2nd row | 0 |
| 3rd row | 0 |
| 4th row | 0 |
| 5th row | 0 |
| Value | Count | Frequency (%) |
| 0 | 15856 | |
| 1 | 2148 | 11.9% |
| Value | Count | Frequency (%) |
| 0 | 15856 | |
| 1 | 2148 | 11.9% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 15856 | |
| 1 | 2148 | 11.9% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 18004 |
Most frequent character per category
| Value | Count | Frequency (%) |
| 0 | 15856 | |
| 1 | 2148 | 11.9% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 18004 |
Most frequent character per script
| Value | Count | Frequency (%) |
| 0 | 15856 | |
| 1 | 2148 | 11.9% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 18004 |
Most frequent character per block
| Value | Count | Frequency (%) |
| 0 | 15856 | |
| 1 | 2148 | 11.9% |
| Distinct | 225 |
|---|---|
| Distinct (%) | 10.5% |
| Missing | 15856 |
| Missing (%) | 88.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 27.87337058 |
| Minimum | 0 |
|---|---|
| Maximum | 1066 |
| Zeros | 610 |
| Zeros (%) | 3.4% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 140.8 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 2 |
| Q3 | 13 |
| 95-th percentile | 158.65 |
| Maximum | 1066 |
| Range | 1066 |
| Interquartile range (IQR) | 13 |
Descriptive statistics
| Standard deviation | 83.21780099 |
|---|---|
| Coefficient of variation (CV) | 2.985566484 |
| Kurtosis | 34.4984913 |
| Mean | 27.87337058 |
| Median Absolute Deviation (MAD) | 2 |
| Skewness | 5.222174053 |
| Sum | 59872 |
| Variance | 6925.202402 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 610 | 3.4% |
| 1 | 328 | 1.8% |
| 2 | 169 | 0.9% |
| 3 | 115 | 0.6% |
| 4 | 74 | 0.4% |
| 7 | 56 | 0.3% |
| 5 | 52 | 0.3% |
| 6 | 52 | 0.3% |
| 8 | 38 | 0.2% |
| 11 | 32 | 0.2% |
| Other values (215) | 622 | 3.5% |
| (Missing) | 15856 |
| Value | Count | Frequency (%) |
| 0 | 610 | |
| 1 | 328 | |
| 2 | 169 | 0.9% |
| 3 | 115 | 0.6% |
| 4 | 74 | 0.4% |
| Value | Count | Frequency (%) |
| 1066 | 1 | |
| 792 | 1 | |
| 741 | 1 | |
| 729 | 1 | |
| 671 | 1 |
has_mock_account
Categorical
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 140.8 KiB |
| 0 | |
|---|---|
| 1 | 77 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 18004 |
|---|---|
| Distinct characters | 2 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0 |
|---|---|
| 2nd row | 0 |
| 3rd row | 0 |
| 4th row | 0 |
| 5th row | 0 |
| Value | Count | Frequency (%) |
| 0 | 17927 | |
| 1 | 77 | 0.4% |
| Value | Count | Frequency (%) |
| 0 | 17927 | |
| 1 | 77 | 0.4% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 17927 | |
| 1 | 77 | 0.4% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 18004 |
Most frequent character per category
| Value | Count | Frequency (%) |
| 0 | 17927 | |
| 1 | 77 | 0.4% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 18004 |
Most frequent character per script
| Value | Count | Frequency (%) |
| 0 | 17927 | |
| 1 | 77 | 0.4% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 18004 |
Most frequent character per block
| Value | Count | Frequency (%) |
| 0 | 17927 | |
| 1 | 77 | 0.4% |
| Distinct | 42 |
|---|---|
| Distinct (%) | 54.5% |
| Missing | 17927 |
| Missing (%) | 99.6% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 71.90909091 |
| Minimum | 0 |
|---|---|
| Maximum | 635 |
| Zeros | 13 |
| Zeros (%) | 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 140.8 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 1 |
| median | 12 |
| Q3 | 75 |
| 95-th percentile | 336.2 |
| Maximum | 635 |
| Range | 635 |
| Interquartile range (IQR) | 74 |
Descriptive statistics
| Standard deviation | 122.6312596 |
|---|---|
| Coefficient of variation (CV) | 1.705365178 |
| Kurtosis | 6.250862559 |
| Mean | 71.90909091 |
| Median Absolute Deviation (MAD) | 12 |
| Skewness | 2.404544909 |
| Sum | 5537 |
| Variance | 15038.42584 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 13 | 0.1% |
| 1 | 8 | < 0.1% |
| 2 | 5 | < 0.1% |
| 4 | 5 | < 0.1% |
| 3 | 3 | < 0.1% |
| 49 | 2 | < 0.1% |
| 266 | 2 | < 0.1% |
| 11 | 2 | < 0.1% |
| 5 | 2 | < 0.1% |
| 152 | 2 | < 0.1% |
| Other values (32) | 33 | 0.2% |
| (Missing) | 17927 |
| Value | Count | Frequency (%) |
| 0 | 13 | |
| 1 | 8 | |
| 2 | 5 | < 0.1% |
| 3 | 3 | < 0.1% |
| 4 | 5 | < 0.1% |
| Value | Count | Frequency (%) |
| 635 | 1 | |
| 414 | 1 | |
| 401 | 1 | |
| 393 | 1 | |
| 322 | 1 |
user_flow_name
Categorical
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 140.8 KiB |
| 2 | |
|---|---|
| 0 | |
| 1 | 178 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 18004 |
|---|---|
| Distinct characters | 3 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 2 |
|---|---|
| 2nd row | 2 |
| 3rd row | 0 |
| 4th row | 2 |
| 5th row | 2 |
| Value | Count | Frequency (%) |
| 2 | 13406 | |
| 0 | 4420 | 24.6% |
| 1 | 178 | 1.0% |
| Value | Count | Frequency (%) |
| 2 | 13406 | |
| 0 | 4420 | 24.6% |
| 1 | 178 | 1.0% |
Most occurring characters
| Value | Count | Frequency (%) |
| 2 | 13406 | |
| 0 | 4420 | 24.6% |
| 1 | 178 | 1.0% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 18004 |
Most frequent character per category
| Value | Count | Frequency (%) |
| 2 | 13406 | |
| 0 | 4420 | 24.6% |
| 1 | 178 | 1.0% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 18004 |
Most frequent character per script
| Value | Count | Frequency (%) |
| 2 | 13406 | |
| 0 | 4420 | 24.6% |
| 1 | 178 | 1.0% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 18004 |
Most frequent character per block
| Value | Count | Frequency (%) |
| 2 | 13406 | |
| 0 | 4420 | 24.6% |
| 1 | 178 | 1.0% |
days_until_conversion_or_today
Real number (ℝ≥0)
| Distinct | 1129 |
|---|---|
| Distinct (%) | 6.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 405.215952 |
| Minimum | 0 |
|---|---|
| Maximum | 1128 |
| Zeros | 102 |
| Zeros (%) | 0.6% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 140.8 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 6 |
| Q1 | 96 |
| median | 351 |
| Q3 | 685 |
| 95-th percentile | 1016 |
| Maximum | 1128 |
| Range | 1128 |
| Interquartile range (IQR) | 589 |
Descriptive statistics
| Standard deviation | 336.2311493 |
|---|---|
| Coefficient of variation (CV) | 0.8297579295 |
| Kurtosis | -0.9962257948 |
| Mean | 405.215952 |
| Median Absolute Deviation (MAD) | 277 |
| Skewness | 0.5132921862 |
| Sum | 7295508 |
| Variance | 113051.3858 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 3 | 164 | 0.9% |
| 4 | 153 | 0.8% |
| 1 | 151 | 0.8% |
| 6 | 142 | 0.8% |
| 7 | 139 | 0.8% |
| 2 | 133 | 0.7% |
| 5 | 121 | 0.7% |
| 8 | 119 | 0.7% |
| 9 | 104 | 0.6% |
| 0 | 102 | 0.6% |
| Other values (1119) | 16676 |
| Value | Count | Frequency (%) |
| 0 | 102 | |
| 1 | 151 | |
| 2 | 133 | |
| 3 | 164 | |
| 4 | 153 |
| Value | Count | Frequency (%) |
| 1128 | 5 | |
| 1127 | 4 | < 0.1% |
| 1126 | 10 | |
| 1125 | 8 | |
| 1124 | 5 |
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 140.8 KiB |
| 0 | |
|---|---|
| 1 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 18004 |
|---|---|
| Distinct characters | 2 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 1 |
|---|---|
| 2nd row | 1 |
| 3rd row | 0 |
| 4th row | 0 |
| 5th row | 0 |
| Value | Count | Frequency (%) |
| 0 | 13666 | |
| 1 | 4338 | 24.1% |
| Value | Count | Frequency (%) |
| 0 | 13666 | |
| 1 | 4338 | 24.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 13666 | |
| 1 | 4338 | 24.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 18004 |
Most frequent character per category
| Value | Count | Frequency (%) |
| 0 | 13666 | |
| 1 | 4338 | 24.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 18004 |
Most frequent character per script
| Value | Count | Frequency (%) |
| 0 | 13666 | |
| 1 | 4338 | 24.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 18004 |
Most frequent character per block
| Value | Count | Frequency (%) |
| 0 | 13666 | |
| 1 | 4338 | 24.1% |
Pearson's r
The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.
Spearman's ρ
The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.
Kendall's τ
Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.
Phik (φk)
Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.Cramér's V (φc)
Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.First rows
| user_currency | user_country | start_mifid_days | has_finished_mifid | finish_mifid_days | has_deposit | first_deposit_days | first_deposit_amount | first_deposit_platform | mifid_actual_savings | mifid_next_year_savings | mifid_qualifications | mifid_money_other_brokers | mifid_invested_other_brokers | mifid_experience | has_linked_account | linked_account_days | has_demo_account | demo_account_days | has_demo_trade | demo_trade_days | has_mock_account | mock_account_days | user_flow_name | days_until_conversion_or_today | is_converted | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | EUR | 46 | 0.0 | 1 | 1.0 | 1 | 1.0 | 2.0 | 0 | 5 | 6 | 1 | 1 | 6 | 1 | 0 | NaN | 0 | NaN | 0 | NaN | 0 | NaN | 2 | 1 | 1 |
| 1 | EUR | 46 | 0.0 | 1 | 0.0 | 1 | 2.0 | 20.0 | 0 | 8 | 8 | 1 | 1 | 6 | 0 | 0 | NaN | 0 | NaN | 0 | NaN | 0 | NaN | 2 | 2 | 1 |
| 2 | USD | 43 | 4.0 | 1 | 7.0 | 0 | NaN | 0.0 | 1 | 12 | 12 | 1 | 1 | 12 | 0 | 0 | NaN | 0 | NaN | 0 | NaN | 0 | NaN | 0 | 8 | 0 |
| 3 | USD | 31 | 0.0 | 0 | NaN | 0 | NaN | 0.0 | 1 | 13 | 13 | 0 | 1 | 12 | 0 | 0 | NaN | 0 | NaN | 0 | NaN | 0 | NaN | 2 | 8 | 0 |
| 4 | USD | 22 | 0.0 | 0 | NaN | 0 | NaN | 0.0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NaN | 0 | NaN | 0 | NaN | 0 | NaN | 2 | 8 | 0 |
| 5 | EUR | 36 | 0.0 | 1 | 1.0 | 0 | NaN | 0.0 | 1 | 9 | 7 | 1 | 1 | 7 | 1 | 0 | NaN | 0 | NaN | 0 | NaN | 0 | NaN | 2 | 8 | 0 |
| 6 | EUR | 50 | 0.0 | 1 | 1.0 | 0 | NaN | 0.0 | 1 | 9 | 8 | 1 | 1 | 6 | 1 | 0 | NaN | 0 | NaN | 0 | NaN | 0 | NaN | 2 | 8 | 0 |
| 7 | USD | 41 | 0.0 | 0 | NaN | 0 | NaN | 0.0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NaN | 0 | NaN | 0 | NaN | 0 | NaN | 2 | 8 | 0 |
| 8 | USD | 22 | 0.0 | 1 | 0.0 | 0 | NaN | 0.0 | 1 | 8 | 6 | 1 | 1 | 8 | 1 | 0 | NaN | 0 | NaN | 0 | NaN | 0 | NaN | 2 | 8 | 0 |
| 9 | EUR | 153 | 0.0 | 1 | 1.0 | 0 | NaN | 0.0 | 1 | 12 | 12 | 0 | 0 | 0 | 0 | 0 | NaN | 0 | NaN | 0 | NaN | 0 | NaN | 2 | 8 | 0 |
Last rows
| user_currency | user_country | start_mifid_days | has_finished_mifid | finish_mifid_days | has_deposit | first_deposit_days | first_deposit_amount | first_deposit_platform | mifid_actual_savings | mifid_next_year_savings | mifid_qualifications | mifid_money_other_brokers | mifid_invested_other_brokers | mifid_experience | has_linked_account | linked_account_days | has_demo_account | demo_account_days | has_demo_trade | demo_trade_days | has_mock_account | mock_account_days | user_flow_name | days_until_conversion_or_today | is_converted | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 17994 | USD | 30 | 0.0 | 0 | NaN | 0 | NaN | 0.0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NaN | 0 | NaN | 0 | NaN | 0 | NaN | 2 | 1127 | 0 |
| 17995 | USD | 31 | 206.0 | 1 | 229.0 | 1 | 380.0 | 2.4 | 5 | 13 | 5 | 1 | 1 | 13 | 1 | 0 | NaN | 0 | NaN | 0 | NaN | 0 | NaN | 2 | 1127 | 0 |
| 17996 | USD | 30 | 43.0 | 0 | NaN | 0 | NaN | 0.0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NaN | 0 | NaN | 0 | NaN | 0 | NaN | 2 | 1127 | 0 |
| 17997 | USD | 160 | 1.0 | 1 | 31.0 | 1 | 393.0 | 2.0 | 2 | 12 | 12 | 1 | 0 | 0 | 1 | 1 | 87.0 | 1 | 84.0 | 1 | 84.0 | 0 | NaN | 2 | 394 | 1 |
| 17998 | EUR | 46 | 0.0 | 1 | 1.0 | 1 | 3.0 | 2.0 | 5 | 13 | 13 | 1 | 0 | 0 | 1 | 0 | NaN | 0 | NaN | 0 | NaN | 0 | NaN | 2 | 6 | 1 |
| 17999 | EUR | 46 | 79.0 | 0 | NaN | 0 | NaN | 0.0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NaN | 0 | NaN | 0 | NaN | 0 | NaN | 2 | 1128 | 0 |
| 18000 | USD | 74 | 0.0 | 0 | NaN | 0 | NaN | 0.0 | 1 | 5 | 7 | 1 | 0 | 0 | 1 | 0 | NaN | 0 | NaN | 0 | NaN | 0 | NaN | 2 | 1128 | 0 |
| 18001 | EUR | 46 | 0.0 | 0 | NaN | 0 | NaN | 0.0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NaN | 0 | NaN | 0 | NaN | 0 | NaN | 2 | 1128 | 0 |
| 18002 | EUR | 0 | 0.0 | 1 | 260.0 | 0 | NaN | 0.0 | 1 | 10 | 6 | 0 | 0 | 0 | 0 | 0 | NaN | 0 | NaN | 0 | NaN | 0 | NaN | 2 | 1128 | 0 |
| 18003 | GBP | 74 | 3.0 | 0 | NaN | 0 | NaN | 0.0 | 1 | 7 | 12 | 1 | 0 | 0 | 1 | 0 | NaN | 0 | NaN | 0 | NaN | 0 | NaN | 2 | 1128 | 0 |